Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitGroupID (FK)(PK) | A unique system assigned identifier for a group of BusinessUnits. | ID_BSNGP | Identity | integer | BusinessUnitGroupItem(AS_BSNGP_ITM) |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | BusinessUnitGroupItem(AS_BSNGP_ITM) |
EffectiveDateTime (FK)(PK) | The date from which the BusinessUnits in the group carry the Item. | TS_EF | EffectiveDateTime | datetime | BusinessUnitGroupItem(AS_BSNGP_ITM) |
EventID (FK)(PK) | A unique, automatically assigned identifier for the Event | ID_EV | Identity | integer | PermanentPriceChange(TR_CHN_PRN_PRC) |
NewPrice | The new Permanent Retail Price to be applied to the Item in all stores in the RetailStoreGroup as a consequence of the PriceChangeEvent | MO_PRC_NW | MoneyShortRetail | decimal(7,2) | |